SELECT col3 , LAG(col3 ) OVER ( PARTITION BY col2 ORDER BY col0 ) LAG_col3 FROM "fewRowsAllData.parquet"